Budget Global Sum

Use the 20 Budget Global Sum (Global Sum) driver to budget accounts that are calculated as a percentage of other revenue or statistical accounts. This driver uses totals from the Stat_Rev tab as the calculation base and applies the calculated results to the appropriate Stat_Rev or Expense tab, depending on the account.

The Global Sum driver is commonly used for items such as allowances, bad debt, or other adjustments that should scale with revenue or volume rather than be entered as fixed amounts. When the underlying Stat_Rev values change, the calculated results update automatically.

You can use this driver to calculate a budgeted value for a department and account by applying a percentage to selected Stat_Rev accounts.

You can add additional rows by copying the formulas from the ones already set up.

IMPORTANT: Do not change the codes in Row1 or delete any columns without consulting without consulting an Administrator first.

Configure settings

Before opening the driver, configure the required accounts in the ACCT dimension.

This driver uses accounts that are classified as GlobalSum in the ACCT dimension standard line (StdLine) column. You must complete this setup before using the driver.

1. Go to Admin > Admin Task Panes > Budget Admin > View Dimension Tables.

2. Double-click ACCT and complete the Open Table in Spreadsheet form.

3. Find the account in the Account Number column.

4. Double-click the StdLine field (for example, KHAStdLine) to view the calculation method values.

5. Select GlobalSum.

6. To save, right click the ACCT tab and select Save.

Configure driver settings.

1. Go to Admin > Admin Task Panes > Budget Admin > Budget Assumptions and double click the desired driver set:
   • Access NY Budget Assumptions (next year's budget drivers)
   • Access CY Budget Assumptions (current year's budget drivers)

   • Choose the refresh variables.

     NOTE: Refresh variable selection depends on the driver's requirements. Some values may not display, and not all drivers include refresh variable options.

     Tips:

     • When refresh variables require a standard line, you must select at least one. If none are selected, the OK button is disabled.

     

     • KHAStdLine is the default for the following drivers: Budget Global Data (7-10), Global Depreciation (05), Global Expense Budget (11), and Budget Revenue Global Revenue (12).

     • Department selection appears for the following drivers: Budget Statistics (03), Budget Depreciation (05), Global Expense Budget (11), Global Revenue Budget (12), Budget Global Sum (20), Budget Global Labor Premium Dollars (23), Budget Labor Benchmark (24), Budget Labor Target (28), Budget Provider Simple Dept Config (36), (42) Bugdet Stat Account.

     

2. To save any changes, right click the driver tab and select Save > Save Data Only.

Global Sum configuration includes the following tasks:

• Configure Revenue Accounts to be Summed section

• Configure Accounts to Use GlobalSum Methodology section